-- Copyright (C) 2007 ETH Zurich
--
-- This file is part of Fosstrak (www.fosstrak.org).
--
-- Fosstrak is free software; you can redistribute it and/or
-- modify it under the terms of the GNU Lesser General Public
-- License version 2.1, as published by the Free Software Foundation.
--
-- Fosstrak is distributed in the hope that it will be useful,
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
-- Lesser General Public License for more details.
--
-- You should have received a copy of the GNU Lesser General Public
-- License along with Fosstrak; if not, write to the Free
-- Software Foundation, Inc., 51 Franklin Street, Fifth Floor,
-- Boston, MA  02110-1301  USA


-- This script adds the event and master data to the EPCIS database which is
-- required by the interoperability tests.

BEGIN;

INSERT INTO `BizTransaction` VALUES (41,41,9),(42,42,9),(43,43,9),(44,44,9),(45,45,9),(46,46,10),(47,47,10),(48,48,10),(49,49,10),(50,50,10);
INSERT INTO `event_AggregationEvent` VALUES (41,'2006-06-25 03:51:00',1151200260000,'2006-06-25 03:51:00',1151200260000,'-06:00','urn:epc:id:sscc:0614141.0000000001','ADD',22,9,21,25),(42,'2006-06-25 03:52:00',1151200320000,'2006-06-25 03:52:00',1151200320000,'-06:00','urn:epc:id:sscc:0614141.0000000002','ADD',22,9,21,25),(43,'2006-06-25 03:53:00',1151200380000,'2006-06-25 03:53:00',1151200380000,'-06:00','urn:epc:id:sscc:0614141.0000000003','ADD',22,9,21,25),(44,'2006-06-25 03:54:00',1151200440000,'2006-06-25 03:54:00',1151200440000,'-06:00','urn:epc:id:sscc:0614141.0000000004','ADD',22,9,21,25),(45,'2006-06-25 03:55:00',1151200500000,'2006-06-25 03:55:00',1151200500000,'-06:00','urn:epc:id:sscc:0614141.0000000005','ADD',22,9,21,25),(46,'2006-06-25 03:56:00',1151200560000,'2006-06-25 03:56:00',1151200560000,'-06:00','urn:epc:id:sscc:0614142.0000000006','ADD',22,9,21,25),(47,'2006-06-25 03:57:00',1151200620000,'2006-06-25 03:57:00',1151200620000,'-06:00','urn:epc:id:sscc:0614142.0000000007','ADD',22,9,21,25),(48,'2006-06-25 03:58:00',1151200680000,'2006-06-25 03:58:00',1151200680000,'-06:00','urn:epc:id:sscc:0614142.0000000008','ADD',22,9,21,25),(49,'2006-06-25 03:59:00',1151200740000,'2006-06-25 03:59:00',1151200740000,'-06:00','urn:epc:id:sscc:0614142.0000000009','ADD',22,9,21,25),(50,'2006-06-25 04:00:00',1151200800000,'2006-06-25 04:00:00',1151200800000,'-06:00','urn:epc:id:sscc:0614142.0000000010','ADD',22,9,21,25);
INSERT INTO `event_AggregationEvent_EPCs` VALUES (41,'urn:epc:id:sgtin:0614141.107340.1',0),(41,'urn:epc:id:sgtin:0614141.107340.2',1),(41,'urn:epc:id:sgtin:0614141.107340.3',2),(41,'urn:epc:id:sgtin:0614141.107340.4',3),(41,'urn:epc:id:sgtin:0614141.107340.5',4),(41,'urn:epc:id:sgtin:0614141.107340.6',5),(41,'urn:epc:id:sgtin:0614141.107340.7',6),(41,'urn:epc:id:sgtin:0614141.107340.8',7),(41,'urn:epc:id:sgtin:0614141.107340.9',8),(41,'urn:epc:id:sgtin:0614141.107340.10',9),(42,'urn:epc:id:sgtin:0614141.107341.1',10),(42,'urn:epc:id:sgtin:0614141.107341.2',11),(42,'urn:epc:id:sgtin:0614141.107341.3',12),(42,'urn:epc:id:sgtin:0614141.107341.4',13),(42,'urn:epc:id:sgtin:0614141.107341.5',14),(42,'urn:epc:id:sgtin:0614141.107341.6',15),(42,'urn:epc:id:sgtin:0614141.107341.7',16),(42,'urn:epc:id:sgtin:0614141.107341.8',17),(42,'urn:epc:id:sgtin:0614141.107341.9',18),(42,'urn:epc:id:sgtin:0614141.107341.10',19),(43,'urn:epc:id:sgtin:0614141.107342.1',20),(43,'urn:epc:id:sgtin:0614141.107342.2',21),(43,'urn:epc:id:sgtin:0614141.107342.3',22),(43,'urn:epc:id:sgtin:0614141.107342.4',23),(43,'urn:epc:id:sgtin:0614141.107342.5',24),(43,'urn:epc:id:sgtin:0614141.107342.6',25),(43,'urn:epc:id:sgtin:0614141.107342.7',26),(43,'urn:epc:id:sgtin:0614141.107342.8',27),(43,'urn:epc:id:sgtin:0614141.107342.9',28),(43,'urn:epc:id:sgtin:0614141.107342.10',29),(44,'urn:epc:id:sgtin:0614141.107343.1',30),(44,'urn:epc:id:sgtin:0614141.107343.2',31),(44,'urn:epc:id:sgtin:0614141.107343.3',32),(44,'urn:epc:id:sgtin:0614141.107343.4',33),(44,'urn:epc:id:sgtin:0614141.107343.5',34),(44,'urn:epc:id:sgtin:0614141.107343.6',35),(44,'urn:epc:id:sgtin:0614141.107343.7',36),(44,'urn:epc:id:sgtin:0614141.107343.8',37),(44,'urn:epc:id:sgtin:0614141.107343.9',38),(44,'urn:epc:id:sgtin:0614141.107343.10',39),(45,'urn:epc:id:sgtin:0614141.107344.1',40),(45,'urn:epc:id:sgtin:0614141.107344.2',41),(45,'urn:epc:id:sgtin:0614141.107344.3',42),(45,'urn:epc:id:sgtin:0614141.107344.4',43),(45,'urn:epc:id:sgtin:0614141.107344.5',44),(45,'urn:epc:id:sgtin:0614141.107344.6',45),(45,'urn:epc:id:sgtin:0614141.107344.7',46),(45,'urn:epc:id:sgtin:0614141.107344.8',47),(45,'urn:epc:id:sgtin:0614141.107344.9',48),(45,'urn:epc:id:sgtin:0614141.107344.10',49),(46,'urn:epc:id:sgtin:0614142.107345.1',50),(46,'urn:epc:id:sgtin:0614142.107345.2',51),(46,'urn:epc:id:sgtin:0614142.107345.3',52),(46,'urn:epc:id:sgtin:0614142.107345.4',53),(46,'urn:epc:id:sgtin:0614142.107345.5',54),(46,'urn:epc:id:sgtin:0614142.107345.6',55),(46,'urn:epc:id:sgtin:0614142.107345.7',56),(46,'urn:epc:id:sgtin:0614142.107345.8',57),(46,'urn:epc:id:sgtin:0614142.107345.9',58),(46,'urn:epc:id:sgtin:0614142.107345.10',59),(47,'urn:epc:id:sgtin:0614142.107346.1',60),(47,'urn:epc:id:sgtin:0614142.107346.2',61),(47,'urn:epc:id:sgtin:0614142.107346.3',62),(47,'urn:epc:id:sgtin:0614142.107346.4',63),(47,'urn:epc:id:sgtin:0614142.107346.5',64),(47,'urn:epc:id:sgtin:0614142.107346.6',65),(47,'urn:epc:id:sgtin:0614142.107346.7',66),(47,'urn:epc:id:sgtin:0614142.107346.8',67),(47,'urn:epc:id:sgtin:0614142.107346.9',68),(47,'urn:epc:id:sgtin:0614142.107346.10',69),(48,'urn:epc:id:sgtin:0614142.107347.1',70),(48,'urn:epc:id:sgtin:0614142.107347.2',71),(48,'urn:epc:id:sgtin:0614142.107347.3',72),(48,'urn:epc:id:sgtin:0614142.107347.4',73),(48,'urn:epc:id:sgtin:0614142.107347.5',74),(48,'urn:epc:id:sgtin:0614142.107347.6',75),(48,'urn:epc:id:sgtin:0614142.107347.7',76),(48,'urn:epc:id:sgtin:0614142.107347.8',77),(48,'urn:epc:id:sgtin:0614142.107347.9',78),(48,'urn:epc:id:sgtin:0614142.107347.10',79),(49,'urn:epc:id:sgtin:0614142.107348.1',80),(49,'urn:epc:id:sgtin:0614142.107348.2',81),(49,'urn:epc:id:sgtin:0614142.107348.3',82),(49,'urn:epc:id:sgtin:0614142.107348.4',83),(49,'urn:epc:id:sgtin:0614142.107348.5',84),(49,'urn:epc:id:sgtin:0614142.107348.6',85),(49,'urn:epc:id:sgtin:0614142.107348.7',86),(49,'urn:epc:id:sgtin:0614142.107348.8',87),(49,'urn:epc:id:sgtin:0614142.107348.9',88),(49,'urn:epc:id:sgtin:0614142.107348.10',89),(50,'urn:epc:id:sgtin:0614142.107349.1',90),(50,'urn:epc:id:sgtin:0614142.107349.2',91),(50,'urn:epc:id:sgtin:0614142.107349.3',92),(50,'urn:epc:id:sgtin:0614142.107349.4',93),(50,'urn:epc:id:sgtin:0614142.107349.5',94),(50,'urn:epc:id:sgtin:0614142.107349.6',95),(50,'urn:epc:id:sgtin:0614142.107349.7',96),(50,'urn:epc:id:sgtin:0614142.107349.8',97),(50,'urn:epc:id:sgtin:0614142.107349.9',98),(50,'urn:epc:id:sgtin:0614142.107349.10',99);
INSERT INTO `event_ObjectEvent` VALUES (501,'2006-06-25 00:01:00',1151186460000,'2006-06-25 00:01:00',1151186460000,'-06:00','ADD',21,9,21,25),(502,'2006-06-25 00:02:00',1151186520000,'2006-06-25 00:02:00',1151186520000,'-06:00','ADD',21,9,21,25),(503,'2006-06-25 00:03:00',1151186580000,'2006-06-25 00:03:00',1151186580000,'-06:00','ADD',21,9,21,25),(504,'2006-06-25 00:04:00',1151186640000,'2006-06-25 00:04:00',1151186640000,'-06:00','ADD',21,9,21,25),(505,'2006-06-25 00:05:00',1151186700000,'2006-06-25 00:05:00',1151186700000,'-06:00','ADD',21,9,21,25),(506,'2006-06-25 00:06:00',1151186760000,'2006-06-25 00:06:00',1151186760000,'-06:00','ADD',21,9,21,25),(507,'2006-06-25 00:07:00',1151186820000,'2006-06-25 00:07:00',1151186820000,'-06:00','ADD',21,9,21,25),(508,'2006-06-25 00:08:00',1151186880000,'2006-06-25 00:08:00',1151186880000,'-06:00','ADD',21,9,21,25),(509,'2006-06-25 00:09:00',1151186940000,'2006-06-25 00:09:00',1151186940000,'-06:00','ADD',21,9,21,25),(510,'2006-06-25 00:10:00',1151187000000,'2006-06-25 00:10:00',1151187000000,'-06:00','ADD',21,9,21,25),(511,'2006-06-25 00:11:00',1151187060000,'2006-06-25 00:11:00',1151187060000,'-06:00','ADD',21,9,21,25),(512,'2006-06-25 00:12:00',1151187120000,'2006-06-25 00:12:00',1151187120000,'-06:00','ADD',21,9,21,25),(513,'2006-06-25 00:13:00',1151187180000,'2006-06-25 00:13:00',1151187180000,'-06:00','ADD',21,9,21,25),(514,'2006-06-25 00:14:00',1151187240000,'2006-06-25 00:14:00',1151187240000,'-06:00','ADD',21,9,21,25),(515,'2006-06-25 00:15:00',1151187300000,'2006-06-25 00:15:00',1151187300000,'-06:00','ADD',21,9,21,25),(516,'2006-06-25 00:16:00',1151187360000,'2006-06-25 00:16:00',1151187360000,'-06:00','ADD',21,9,21,25),(517,'2006-06-25 00:17:00',1151187420000,'2006-06-25 00:17:00',1151187420000,'-06:00','ADD',21,9,21,25),(518,'2006-06-25 00:18:00',1151187480000,'2006-06-25 00:18:00',1151187480000,'-06:00','ADD',21,9,21,25),(519,'2006-06-25 00:19:00',1151187540000,'2006-06-25 00:19:00',1151187540000,'-06:00','ADD',21,9,21,25),(520,'2006-06-25 00:20:00',1151187600000,'2006-06-25 00:20:00',1151187600000,'-06:00','ADD',21,9,21,25),(521,'2006-06-25 00:21:00',1151187660000,'2006-06-25 00:21:00',1151187660000,'-06:00','ADD',21,9,21,25),(522,'2006-06-25 00:22:00',1151187720000,'2006-06-25 00:22:00',1151187720000,'-06:00','ADD',21,9,21,25),(523,'2006-06-25 00:23:00',1151187780000,'2006-06-25 00:23:00',1151187780000,'-06:00','ADD',21,9,21,25),(524,'2006-06-25 00:24:00',1151187840000,'2006-06-25 00:24:00',1151187840000,'-06:00','ADD',21,9,21,25),(525,'2006-06-25 00:25:00',1151187900000,'2006-06-25 00:25:00',1151187900000,'-06:00','ADD',21,9,21,25),(526,'2006-06-25 00:26:00',1151187960000,'2006-06-25 00:26:00',1151187960000,'-06:00','ADD',21,9,21,25),(527,'2006-06-25 00:27:00',1151188020000,'2006-06-25 00:27:00',1151188020000,'-06:00','ADD',21,9,21,25),(528,'2006-06-25 00:28:00',1151188080000,'2006-06-25 00:28:00',1151188080000,'-06:00','ADD',21,9,21,25),(529,'2006-06-25 00:29:00',1151188140000,'2006-06-25 00:29:00',1151188140000,'-06:00','ADD',21,9,21,25),(530,'2006-06-25 00:30:00',1151188200000,'2006-06-25 00:30:00',1151188200000,'-06:00','ADD',21,9,21,25),(531,'2006-06-25 00:31:00',1151188260000,'2006-06-25 00:31:00',1151188260000,'-06:00','ADD',21,9,21,25),(532,'2006-06-25 00:32:00',1151188320000,'2006-06-25 00:32:00',1151188320000,'-06:00','ADD',21,9,21,25),(533,'2006-06-25 00:33:00',1151188380000,'2006-06-25 00:33:00',1151188380000,'-06:00','ADD',21,9,21,25),(534,'2006-06-25 00:34:00',1151188440000,'2006-06-25 00:34:00',1151188440000,'-06:00','ADD',21,9,21,25),(535,'2006-06-25 00:35:00',1151188500000,'2006-06-25 00:35:00',1151188500000,'-06:00','ADD',21,9,21,25),(536,'2006-06-25 00:36:00',1151188560000,'2006-06-25 00:36:00',1151188560000,'-06:00','ADD',21,9,21,25),(537,'2006-06-25 00:37:00',1151188620000,'2006-06-25 00:37:00',1151188620000,'-06:00','ADD',21,9,21,25),(538,'2006-06-25 00:38:00',1151188680000,'2006-06-25 00:38:00',1151188680000,'-06:00','ADD',21,9,21,25),(539,'2006-06-25 00:39:00',1151188740000,'2006-06-25 00:39:00',1151188740000,'-06:00','ADD',21,9,21,25),(540,'2006-06-25 00:40:00',1151188800000,'2006-06-25 00:40:00',1151188800000,'-06:00','ADD',21,9,21,25),(541,'2006-06-25 00:41:00',1151188860000,'2006-06-25 00:41:00',1151188860000,'-06:00','ADD',21,9,21,25),(542,'2006-06-25 00:42:00',1151188920000,'2006-06-25 00:42:00',1151188920000,'-06:00','ADD',21,9,21,25),(543,'2006-06-25 00:43:00',1151188980000,'2006-06-25 00:43:00',1151188980000,'-06:00','ADD',21,9,21,25),(544,'2006-06-25 00:44:00',1151189040000,'2006-06-25 00:44:00',1151189040000,'-06:00','ADD',21,9,21,25),(545,'2006-06-25 00:45:00',1151189100000,'2006-06-25 00:45:00',1151189100000,'-06:00','ADD',21,9,21,25),(546,'2006-06-25 00:46:00',1151189160000,'2006-06-25 00:46:00',1151189160000,'-06:00','ADD',21,9,21,25),(547,'2006-06-25 00:47:00',1151189220000,'2006-06-25 00:47:00',1151189220000,'-06:00','ADD',21,9,21,25),(548,'2006-06-25 00:48:00',1151189280000,'2006-06-25 00:48:00',1151189280000,'-06:00','ADD',21,9,21,25),(549,'2006-06-25 00:49:00',1151189340000,'2006-06-25 00:49:00',1151189340000,'-06:00','ADD',21,9,21,25),(550,'2006-06-25 00:50:00',1151189400000,'2006-06-25 00:50:00',1151189400000,'-06:00','ADD',21,9,21,25),(551,'2006-06-25 00:51:00',1151189460000,'2006-06-25 00:51:00',1151189460000,'-06:00','ADD',21,9,21,25),(552,'2006-06-25 00:52:00',1151189520000,'2006-06-25 00:52:00',1151189520000,'-06:00','ADD',21,9,21,25),(553,'2006-06-25 00:53:00',1151189580000,'2006-06-25 00:53:00',1151189580000,'-06:00','ADD',21,9,21,25),(554,'2006-06-25 00:54:00',1151189640000,'2006-06-25 00:54:00',1151189640000,'-06:00','ADD',21,9,21,25),(555,'2006-06-25 00:55:00',1151189700000,'2006-06-25 00:55:00',1151189700000,'-06:00','ADD',21,9,21,25),(556,'2006-06-25 00:56:00',1151189760000,'2006-06-25 00:56:00',1151189760000,'-06:00','ADD',21,9,21,25),(557,'2006-06-25 00:57:00',1151189820000,'2006-06-25 00:57:00',1151189820000,'-06:00','ADD',21,9,21,25),(558,'2006-06-25 00:58:00',1151189880000,'2006-06-25 00:58:00',1151189880000,'-06:00','ADD',21,9,21,25),(559,'2006-06-25 00:59:00',1151189940000,'2006-06-25 00:59:00',1151189940000,'-06:00','ADD',21,9,21,25),(560,'2006-06-25 01:00:00',1151190000000,'2006-06-25 01:00:00',1151190000000,'-06:00','ADD',21,9,21,25),(561,'2006-06-25 01:01:00',1151190060000,'2006-06-25 01:01:00',1151190060000,'-06:00','ADD',21,9,21,25),(562,'2006-06-25 01:02:00',1151190120000,'2006-06-25 01:02:00',1151190120000,'-06:00','ADD',21,9,21,25),(563,'2006-06-25 01:03:00',1151190180000,'2006-06-25 01:03:00',1151190180000,'-06:00','ADD',21,9,21,25),(564,'2006-06-25 01:04:00',1151190240000,'2006-06-25 01:04:00',1151190240000,'-06:00','ADD',21,9,21,25),(565,'2006-06-25 01:05:00',1151190300000,'2006-06-25 01:05:00',1151190300000,'-06:00','ADD',21,9,21,25),(566,'2006-06-25 01:06:00',1151190360000,'2006-06-25 01:06:00',1151190360000,'-06:00','ADD',21,9,21,25),(567,'2006-06-25 01:07:00',1151190420000,'2006-06-25 01:07:00',1151190420000,'-06:00','ADD',21,9,21,25),(568,'2006-06-25 01:08:00',1151190480000,'2006-06-25 01:08:00',1151190480000,'-06:00','ADD',21,9,21,25),(569,'2006-06-25 01:09:00',1151190540000,'2006-06-25 01:09:00',1151190540000,'-06:00','ADD',21,9,21,25),(570,'2006-06-25 01:10:00',1151190600000,'2006-06-25 01:10:00',1151190600000,'-06:00','ADD',21,9,21,25),(571,'2006-06-25 01:11:00',1151190660000,'2006-06-25 01:11:00',1151190660000,'-06:00','ADD',21,9,21,25),(572,'2006-06-25 01:12:00',1151190720000,'2006-06-25 01:12:00',1151190720000,'-06:00','ADD',21,9,21,25),(573,'2006-06-25 01:13:00',1151190780000,'2006-06-25 01:13:00',1151190780000,'-06:00','ADD',21,9,21,25),(574,'2006-06-25 01:14:00',1151190840000,'2006-06-25 01:14:00',1151190840000,'-06:00','ADD',21,9,21,25),(575,'2006-06-25 01:15:00',1151190900000,'2006-06-25 01:15:00',1151190900000,'-06:00','ADD',21,9,21,25),(576,'2006-06-25 01:16:00',1151190960000,'2006-06-25 01:16:00',1151190960000,'-06:00','ADD',21,9,21,25),(577,'2006-06-25 01:17:00',1151191020000,'2006-06-25 01:17:00',1151191020000,'-06:00','ADD',21,9,21,25),(578,'2006-06-25 01:18:00',1151191080000,'2006-06-25 01:18:00',1151191080000,'-06:00','ADD',21,9,21,25),(579,'2006-06-25 01:19:00',1151191140000,'2006-06-25 01:19:00',1151191140000,'-06:00','ADD',21,9,21,25),(580,'2006-06-25 01:20:00',1151191200000,'2006-06-25 01:20:00',1151191200000,'-06:00','ADD',21,9,21,25),(581,'2006-06-25 01:21:00',1151191260000,'2006-06-25 01:21:00',1151191260000,'-06:00','ADD',21,9,21,25),(582,'2006-06-25 01:22:00',1151191320000,'2006-06-25 01:22:00',1151191320000,'-06:00','ADD',21,9,21,25),(583,'2006-06-25 01:23:00',1151191380000,'2006-06-25 01:23:00',1151191380000,'-06:00','ADD',21,9,21,25),(584,'2006-06-25 01:24:00',1151191440000,'2006-06-25 01:24:00',1151191440000,'-06:00','ADD',21,9,21,25),(585,'2006-06-25 01:25:00',1151191500000,'2006-06-25 01:25:00',1151191500000,'-06:00','ADD',21,9,21,25),(586,'2006-06-25 01:26:00',1151191560000,'2006-06-25 01:26:00',1151191560000,'-06:00','ADD',21,9,21,25),(587,'2006-06-25 01:27:00',1151191620000,'2006-06-25 01:27:00',1151191620000,'-06:00','ADD',21,9,21,25),(588,'2006-06-25 01:28:00',1151191680000,'2006-06-25 01:28:00',1151191680000,'-06:00','ADD',21,9,21,25),(589,'2006-06-25 01:29:00',1151191740000,'2006-06-25 01:29:00',1151191740000,'-06:00','ADD',21,9,21,25),(590,'2006-06-25 01:30:00',1151191800000,'2006-06-25 01:30:00',1151191800000,'-06:00','ADD',21,9,21,25),(591,'2006-06-25 01:31:00',1151191860000,'2006-06-25 01:31:00',1151191860000,'-06:00','ADD',21,9,21,25),(592,'2006-06-25 01:32:00',1151191920000,'2006-06-25 01:32:00',1151191920000,'-06:00','ADD',21,9,21,25),(593,'2006-06-25 01:33:00',1151191980000,'2006-06-25 01:33:00',1151191980000,'-06:00','ADD',21,9,21,25),(594,'2006-06-25 01:34:00',1151192040000,'2006-06-25 01:34:00',1151192040000,'-06:00','ADD',21,9,21,25),(595,'2006-06-25 01:35:00',1151192100000,'2006-06-25 01:35:00',1151192100000,'-06:00','ADD',21,9,21,25),(596,'2006-06-25 01:36:00',1151192160000,'2006-06-25 01:36:00',1151192160000,'-06:00','ADD',21,9,21,25),(597,'2006-06-25 01:37:00',1151192220000,'2006-06-25 01:37:00',1151192220000,'-06:00','ADD',21,9,21,25),(598,'2006-06-25 01:38:00',1151192280000,'2006-06-25 01:38:00',1151192280000,'-06:00','ADD',21,9,21,25),(599,'2006-06-25 01:39:00',1151192340000,'2006-06-25 01:39:00',1151192340000,'-06:00','ADD',21,9,21,25),(600,'2006-06-25 01:40:00',1151192400000,'2006-06-25 01:40:00',1151192400000,'-06:00','ADD',21,9,21,25),(601,'2006-06-25 02:41:00',1151196060000,'2006-06-25 02:41:00',1151196060000,'-06:00','ADD',21,9,21,25),(602,'2006-06-25 02:42:00',1151196120000,'2006-06-25 02:42:00',1151196120000,'-06:00','ADD',21,9,21,25),(603,'2006-06-25 02:43:00',1151196180000,'2006-06-25 02:43:00',1151196180000,'-06:00','ADD',21,9,21,25),(604,'2006-06-25 02:44:00',1151196240000,'2006-06-25 02:44:00',1151196240000,'-06:00','ADD',21,9,21,25),(605,'2006-06-25 02:45:00',1151196300000,'2006-06-25 02:45:00',1151196300000,'-06:00','ADD',21,9,21,25),(606,'2006-06-25 02:46:00',1151196360000,'2006-06-25 02:46:00',1151196360000,'-06:00','ADD',21,9,21,25),(607,'2006-06-25 02:47:00',1151196420000,'2006-06-25 02:47:00',1151196420000,'-06:00','ADD',21,9,21,25),(608,'2006-06-25 02:48:00',1151196480000,'2006-06-25 02:48:00',1151196480000,'-06:00','ADD',21,9,21,25),(609,'2006-06-25 02:49:00',1151196540000,'2006-06-25 02:49:00',1151196540000,'-06:00','ADD',21,9,21,25),(610,'2006-06-25 02:50:00',1151196600000,'2006-06-25 02:50:00',1151196600000,'-06:00','ADD',21,9,21,25),(611,'2006-06-25 05:01:00',1151204460000,'2006-06-25 05:01:00',1151204460000,'-06:00','OBSERVE',23,9,22,26),(612,'2006-06-25 05:02:00',1151204520000,'2006-06-25 05:02:00',1151204520000,'-06:00','OBSERVE',23,9,22,26),(613,'2006-06-25 05:03:00',1151204580000,'2006-06-25 05:03:00',1151204580000,'-06:00','OBSERVE',23,9,22,26),(614,'2006-06-25 05:04:00',1151204640000,'2006-06-25 05:04:00',1151204640000,'-06:00','OBSERVE',23,9,22,26),(615,'2006-06-25 05:05:00',1151204700000,'2006-06-25 05:05:00',1151204700000,'-06:00','OBSERVE',23,9,22,26),(616,'2006-06-25 05:06:00',1151204760000,'2006-06-25 05:06:00',1151204760000,'-06:00','OBSERVE',23,9,22,26),(617,'2006-06-25 05:07:00',1151204820000,'2006-06-25 05:07:00',1151204820000,'-06:00','OBSERVE',23,9,22,26),(618,'2006-06-25 05:08:00',1151204880000,'2006-06-25 05:08:00',1151204880000,'-06:00','OBSERVE',23,9,22,26),(619,'2006-06-25 05:09:00',1151204940000,'2006-06-25 05:09:00',1151204940000,'-06:00','OBSERVE',23,9,22,26),(620,'2006-06-25 05:10:00',1151205000000,'2006-06-25 05:10:00',1151205000000,'-06:00','OBSERVE',23,9,22,26),(621,'2006-06-25 06:11:00',1151208660000,'2006-06-25 06:11:00',1151208660000,'-06:00','OBSERVE',24,9,23,27),(622,'2006-06-25 06:12:00',1151208720000,'2006-06-25 06:12:00',1151208720000,'-06:00','OBSERVE',24,9,23,27),(623,'2006-06-25 06:13:00',1151208780000,'2006-06-25 06:13:00',1151208780000,'-06:00','OBSERVE',24,9,23,27),(624,'2006-06-25 06:14:00',1151208840000,'2006-06-25 06:14:00',1151208840000,'-06:00','OBSERVE',24,9,23,27),(625,'2006-06-25 06:15:00',1151208900000,'2006-06-25 06:15:00',1151208900000,'-06:00','OBSERVE',24,9,23,27);
INSERT INTO `event_ObjectEvent_bizTrans` VALUES (621,41,0),(622,42,1),(623,43,2),(624,44,3),(625,45,4);
INSERT INTO `event_ObjectEvent_EPCs` VALUES (501,'urn:epc:id:sgtin:0614141.107340.1',0),(502,'urn:epc:id:sgtin:0614141.107340.2',1),(503,'urn:epc:id:sgtin:0614141.107340.3',2),(504,'urn:epc:id:sgtin:0614141.107340.4',3),(505,'urn:epc:id:sgtin:0614141.107340.5',4),(506,'urn:epc:id:sgtin:0614141.107340.6',5),(507,'urn:epc:id:sgtin:0614141.107340.7',6),(508,'urn:epc:id:sgtin:0614141.107340.8',7),(509,'urn:epc:id:sgtin:0614141.107340.9',8),(510,'urn:epc:id:sgtin:0614141.107340.10',9),(511,'urn:epc:id:sgtin:0614141.107341.1',10),(512,'urn:epc:id:sgtin:0614141.107341.2',11),(513,'urn:epc:id:sgtin:0614141.107341.3',12),(514,'urn:epc:id:sgtin:0614141.107341.4',13),(515,'urn:epc:id:sgtin:0614141.107341.5',14),(516,'urn:epc:id:sgtin:0614141.107341.6',15),(517,'urn:epc:id:sgtin:0614141.107341.7',16),(518,'urn:epc:id:sgtin:0614141.107341.8',17),(519,'urn:epc:id:sgtin:0614141.107341.9',18),(520,'urn:epc:id:sgtin:0614141.107341.10',19),(521,'urn:epc:id:sgtin:0614141.107342.1',20),(522,'urn:epc:id:sgtin:0614141.107342.2',21),(523,'urn:epc:id:sgtin:0614141.107342.3',22),(524,'urn:epc:id:sgtin:0614141.107342.4',23),(525,'urn:epc:id:sgtin:0614141.107342.5',24),(526,'urn:epc:id:sgtin:0614141.107342.6',25),(527,'urn:epc:id:sgtin:0614141.107342.7',26),(528,'urn:epc:id:sgtin:0614141.107342.8',27),(529,'urn:epc:id:sgtin:0614141.107342.9',28),(530,'urn:epc:id:sgtin:0614141.107342.10',29),(531,'urn:epc:id:sgtin:0614141.107343.1',30),(532,'urn:epc:id:sgtin:0614141.107343.2',31),(533,'urn:epc:id:sgtin:0614141.107343.3',32),(534,'urn:epc:id:sgtin:0614141.107343.4',33),(535,'urn:epc:id:sgtin:0614141.107343.5',34),(536,'urn:epc:id:sgtin:0614141.107343.6',35),(537,'urn:epc:id:sgtin:0614141.107343.7',36),(538,'urn:epc:id:sgtin:0614141.107343.8',37),(539,'urn:epc:id:sgtin:0614141.107343.9',38),(540,'urn:epc:id:sgtin:0614141.107343.10',39),(541,'urn:epc:id:sgtin:0614141.107344.1',40),(542,'urn:epc:id:sgtin:0614141.107344.2',41),(543,'urn:epc:id:sgtin:0614141.107344.3',42),(544,'urn:epc:id:sgtin:0614141.107344.4',43),(545,'urn:epc:id:sgtin:0614141.107344.5',44),(546,'urn:epc:id:sgtin:0614141.107344.6',45),(547,'urn:epc:id:sgtin:0614141.107344.7',46),(548,'urn:epc:id:sgtin:0614141.107344.8',47),(549,'urn:epc:id:sgtin:0614141.107344.9',48),(550,'urn:epc:id:sgtin:0614141.107344.10',49),(551,'urn:epc:id:sgtin:0614142.107345.1',50),(552,'urn:epc:id:sgtin:0614142.107345.2',51),(553,'urn:epc:id:sgtin:0614142.107345.3',52),(554,'urn:epc:id:sgtin:0614142.107345.4',53),(555,'urn:epc:id:sgtin:0614142.107345.5',54),(556,'urn:epc:id:sgtin:0614142.107345.6',55),(557,'urn:epc:id:sgtin:0614142.107345.7',56),(558,'urn:epc:id:sgtin:0614142.107345.8',57),(559,'urn:epc:id:sgtin:0614142.107345.9',58),(560,'urn:epc:id:sgtin:0614142.107345.10',59),(561,'urn:epc:id:sgtin:0614142.107346.1',60),(562,'urn:epc:id:sgtin:0614142.107346.2',61),(563,'urn:epc:id:sgtin:0614142.107346.3',62),(564,'urn:epc:id:sgtin:0614142.107346.4',63),(565,'urn:epc:id:sgtin:0614142.107346.5',64),(566,'urn:epc:id:sgtin:0614142.107346.6',65),(567,'urn:epc:id:sgtin:0614142.107346.7',66),(568,'urn:epc:id:sgtin:0614142.107346.8',67),(569,'urn:epc:id:sgtin:0614142.107346.9',68),(570,'urn:epc:id:sgtin:0614142.107346.10',69),(571,'urn:epc:id:sgtin:0614142.107347.1',70),(572,'urn:epc:id:sgtin:0614142.107347.2',71),(573,'urn:epc:id:sgtin:0614142.107347.3',72),(574,'urn:epc:id:sgtin:0614142.107347.4',73),(575,'urn:epc:id:sgtin:0614142.107347.5',74),(576,'urn:epc:id:sgtin:0614142.107347.6',75),(577,'urn:epc:id:sgtin:0614142.107347.7',76),(578,'urn:epc:id:sgtin:0614142.107347.8',77),(579,'urn:epc:id:sgtin:0614142.107347.9',78),(580,'urn:epc:id:sgtin:0614142.107347.10',79),(581,'urn:epc:id:sgtin:0614142.107348.1',80),(582,'urn:epc:id:sgtin:0614142.107348.2',81),(583,'urn:epc:id:sgtin:0614142.107348.3',82),(584,'urn:epc:id:sgtin:0614142.107348.4',83),(585,'urn:epc:id:sgtin:0614142.107348.5',84),(586,'urn:epc:id:sgtin:0614142.107348.6',85),(587,'urn:epc:id:sgtin:0614142.107348.7',86),(588,'urn:epc:id:sgtin:0614142.107348.8',87),(589,'urn:epc:id:sgtin:0614142.107348.9',88),(590,'urn:epc:id:sgtin:0614142.107348.10',89),(591,'urn:epc:id:sgtin:0614142.107349.1',90),(592,'urn:epc:id:sgtin:0614142.107349.2',91),(593,'urn:epc:id:sgtin:0614142.107349.3',92),(594,'urn:epc:id:sgtin:0614142.107349.4',93),(595,'urn:epc:id:sgtin:0614142.107349.5',94),(596,'urn:epc:id:sgtin:0614142.107349.6',95),(597,'urn:epc:id:sgtin:0614142.107349.7',96),(598,'urn:epc:id:sgtin:0614142.107349.8',97),(599,'urn:epc:id:sgtin:0614142.107349.9',98),(600,'urn:epc:id:sgtin:0614142.107349.10',99),(601,'urn:epc:id:sscc:0614141.0000000001',100),(602,'urn:epc:id:sscc:0614141.0000000002',101),(603,'urn:epc:id:sscc:0614141.0000000003',102),(604,'urn:epc:id:sscc:0614141.0000000004',103),(605,'urn:epc:id:sscc:0614141.0000000005',104),(606,'urn:epc:id:sscc:0614142.0000000006',105),(607,'urn:epc:id:sscc:0614142.0000000007',106),(608,'urn:epc:id:sscc:0614142.0000000008',107),(609,'urn:epc:id:sscc:0614142.0000000009',108),(610,'urn:epc:id:sscc:0614142.0000000010',109),(611,'urn:epc:id:sscc:0614141.0000000001',110),(612,'urn:epc:id:sscc:0614141.0000000002',111),(613,'urn:epc:id:sscc:0614141.0000000003',112),(614,'urn:epc:id:sscc:0614141.0000000004',113),(615,'urn:epc:id:sscc:0614141.0000000005',114),(616,'urn:epc:id:sscc:0614142.0000000006',115),(617,'urn:epc:id:sscc:0614142.0000000007',116),(618,'urn:epc:id:sscc:0614142.0000000008',117),(619,'urn:epc:id:sscc:0614142.0000000009',118),(620,'urn:epc:id:sscc:0614142.0000000010',119),(621,'urn:epc:id:sgtin:0614141.107340.1',120),(621,'urn:epc:id:sgtin:0614141.107340.2',121),(621,'urn:epc:id:sgtin:0614141.107340.3',122),(621,'urn:epc:id:sgtin:0614141.107340.4',123),(621,'urn:epc:id:sgtin:0614141.107340.5',124),(621,'urn:epc:id:sgtin:0614141.107340.6',125),(621,'urn:epc:id:sgtin:0614141.107340.7',126),(621,'urn:epc:id:sgtin:0614141.107340.8',127),(621,'urn:epc:id:sgtin:0614141.107340.9',128),(621,'urn:epc:id:sgtin:0614141.107340.10',129),(621,'urn:epc:id:sgtin:0614141.107341.1',130),(621,'urn:epc:id:sgtin:0614141.107341.2',131),(621,'urn:epc:id:sgtin:0614141.107341.3',132),(621,'urn:epc:id:sgtin:0614141.107341.4',133),(621,'urn:epc:id:sgtin:0614141.107341.5',134),(621,'urn:epc:id:sgtin:0614141.107341.6',135),(621,'urn:epc:id:sgtin:0614141.107341.7',136),(621,'urn:epc:id:sgtin:0614141.107341.8',137),(621,'urn:epc:id:sgtin:0614141.107341.9',138),(621,'urn:epc:id:sgtin:0614141.107341.10',139),(622,'urn:epc:id:sgtin:0614141.107342.1',140),(622,'urn:epc:id:sgtin:0614141.107342.2',141),(622,'urn:epc:id:sgtin:0614141.107342.3',142),(622,'urn:epc:id:sgtin:0614141.107342.4',143),(622,'urn:epc:id:sgtin:0614141.107342.5',144),(622,'urn:epc:id:sgtin:0614141.107342.6',145),(622,'urn:epc:id:sgtin:0614141.107342.7',146),(622,'urn:epc:id:sgtin:0614141.107342.8',147),(622,'urn:epc:id:sgtin:0614141.107342.9',148),(622,'urn:epc:id:sgtin:0614141.107342.10',149),(622,'urn:epc:id:sgtin:0614141.107343.1',150),(622,'urn:epc:id:sgtin:0614141.107343.2',151),(622,'urn:epc:id:sgtin:0614141.107343.3',152),(622,'urn:epc:id:sgtin:0614141.107343.4',153),(622,'urn:epc:id:sgtin:0614141.107343.5',154),(622,'urn:epc:id:sgtin:0614141.107343.6',155),(622,'urn:epc:id:sgtin:0614141.107343.7',156),(622,'urn:epc:id:sgtin:0614141.107343.8',157),(622,'urn:epc:id:sgtin:0614141.107343.9',158),(622,'urn:epc:id:sgtin:0614141.107343.10',159),(623,'urn:epc:id:sgtin:0614141.107344.1',160),(623,'urn:epc:id:sgtin:0614141.107344.2',161),(623,'urn:epc:id:sgtin:0614141.107344.3',162),(623,'urn:epc:id:sgtin:0614141.107344.4',163),(623,'urn:epc:id:sgtin:0614141.107344.5',164),(623,'urn:epc:id:sgtin:0614141.107344.6',165),(623,'urn:epc:id:sgtin:0614141.107344.7',166),(623,'urn:epc:id:sgtin:0614141.107344.8',167),(623,'urn:epc:id:sgtin:0614141.107344.9',168),(623,'urn:epc:id:sgtin:0614141.107344.10',169),(623,'urn:epc:id:sgtin:0614142.107345.1',170),(623,'urn:epc:id:sgtin:0614142.107345.2',171),(623,'urn:epc:id:sgtin:0614142.107345.3',172),(623,'urn:epc:id:sgtin:0614142.107345.4',173),(623,'urn:epc:id:sgtin:0614142.107345.5',174),(623,'urn:epc:id:sgtin:0614142.107345.6',175),(623,'urn:epc:id:sgtin:0614142.107345.7',176),(623,'urn:epc:id:sgtin:0614142.107345.8',177),(623,'urn:epc:id:sgtin:0614142.107345.9',178),(623,'urn:epc:id:sgtin:0614142.107345.10',179),(624,'urn:epc:id:sgtin:0614142.107346.1',180),(624,'urn:epc:id:sgtin:0614142.107346.2',181),(624,'urn:epc:id:sgtin:0614142.107346.3',182),(624,'urn:epc:id:sgtin:0614142.107346.4',183),(624,'urn:epc:id:sgtin:0614142.107346.5',184),(624,'urn:epc:id:sgtin:0614142.107346.6',185),(624,'urn:epc:id:sgtin:0614142.107346.7',186),(624,'urn:epc:id:sgtin:0614142.107346.8',187),(624,'urn:epc:id:sgtin:0614142.107346.9',188),(624,'urn:epc:id:sgtin:0614142.107346.10',189),(624,'urn:epc:id:sgtin:0614142.107347.1',190),(624,'urn:epc:id:sgtin:0614142.107347.2',191),(624,'urn:epc:id:sgtin:0614142.107347.3',192),(624,'urn:epc:id:sgtin:0614142.107347.4',193),(624,'urn:epc:id:sgtin:0614142.107347.5',194),(624,'urn:epc:id:sgtin:0614142.107347.6',195),(624,'urn:epc:id:sgtin:0614142.107347.7',196),(624,'urn:epc:id:sgtin:0614142.107347.8',197),(624,'urn:epc:id:sgtin:0614142.107347.9',198),(624,'urn:epc:id:sgtin:0614142.107347.10',199),(625,'urn:epc:id:sgtin:0614142.107348.1',200),(625,'urn:epc:id:sgtin:0614142.107348.2',201),(625,'urn:epc:id:sgtin:0614142.107348.3',202),(625,'urn:epc:id:sgtin:0614142.107348.4',203),(625,'urn:epc:id:sgtin:0614142.107348.5',204),(625,'urn:epc:id:sgtin:0614142.107348.6',205),(625,'urn:epc:id:sgtin:0614142.107348.7',206),(625,'urn:epc:id:sgtin:0614142.107348.8',207),(625,'urn:epc:id:sgtin:0614142.107348.9',208),(625,'urn:epc:id:sgtin:0614142.107348.10',209),(625,'urn:epc:id:sgtin:0614142.107349.1',210),(625,'urn:epc:id:sgtin:0614142.107349.2',211),(625,'urn:epc:id:sgtin:0614142.107349.3',212),(625,'urn:epc:id:sgtin:0614142.107349.4',213),(625,'urn:epc:id:sgtin:0614142.107349.5',214),(625,'urn:epc:id:sgtin:0614142.107349.6',215),(625,'urn:epc:id:sgtin:0614142.107349.7',216),(625,'urn:epc:id:sgtin:0614142.107349.8',217),(625,'urn:epc:id:sgtin:0614142.107349.9',218),(625,'urn:epc:id:sgtin:0614142.107349.10',219),(670,'urn:epc:id:sgtin:0614141.107340.1',220),(671,'urn:epc:id:sgtin:0614141.107340.1',221),(672,'urn:epc:id:sgtin:0614141.107340.1',222),(673,'urn:epc:id:sgtin:0614141.107340.1',223),(674,'urn:epc:id:sgtin:0614141.107340.1',224),(675,'urn:epc:id:sgtin:0614141.107340.1',225),(676,'urn:epc:id:sgtin:0614141.107340.1',226),(677,'urn:epc:id:sgtin:0614141.107340.1',227),(678,'urn:epc:id:sgtin:0614141.107340.1',228),(679,'urn:epc:id:sgtin:0614141.107340.1',229),(680,'urn:epc:id:sgtin:0614141.107340.1',230),(681,'urn:epc:id:sgtin:0614141.107340.1',231),(682,'urn:epc:id:sgtin:0614141.107340.1',232),(683,'urn:epc:id:sgtin:0614141.107340.1',233),(684,'urn:epc:id:sgtin:0614141.107340.1',234),(685,'urn:epc:id:sgtin:0614141.107340.1',235),(686,'urn:epc:id:sgtin:0614141.107340.1',236),(687,'urn:epc:id:sgtin:0614141.107340.1',237),(688,'urn:epc:id:sgtin:0614141.107340.1',238),(689,'urn:epc:id:sgtin:0614141.107340.1',239);
INSERT INTO `event_ObjectEvent_extensions` VALUES (941,501,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(942,501,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(943,502,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(944,502,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(945,503,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(946,503,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(947,504,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(948,504,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(949,505,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(950,505,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(951,506,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(952,506,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(953,507,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(954,507,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(955,508,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(956,508,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(957,509,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(958,509,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(959,510,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(960,510,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(961,511,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(962,511,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(963,512,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(964,512,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(965,513,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(966,513,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(967,514,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(968,514,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(969,515,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(970,515,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(971,516,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(972,516,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(973,517,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(974,517,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(975,518,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(976,518,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(977,519,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(978,519,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(979,520,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(980,520,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(981,521,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(982,521,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(983,522,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(984,522,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(985,523,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(986,523,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(987,524,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(988,524,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(989,525,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(990,525,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(991,526,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(992,526,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(993,527,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(994,527,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(995,528,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(996,528,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(997,529,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(998,529,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(999,530,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(1000,530,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(1001,531,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(1002,531,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(1003,532,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(1004,532,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(1005,533,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(1006,533,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(1007,534,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(1008,534,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(1009,535,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(1010,535,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(1011,536,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(1012,536,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(1013,537,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(1014,537,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(1015,538,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(1016,538,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(1017,539,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(1018,539,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(1019,540,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(1020,540,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(1021,541,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(1022,541,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(1023,542,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(1024,542,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(1025,543,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(1026,543,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(1027,544,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(1028,544,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(1029,545,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(1030,545,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(1031,546,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(1032,546,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(1033,547,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(1034,547,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(1035,548,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(1036,548,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(1037,549,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(1038,549,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(1039,550,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(1040,550,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(1041,551,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1042,551,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1043,552,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1044,552,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1045,553,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1046,553,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1047,554,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1048,554,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1049,555,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1050,555,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1051,556,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1052,556,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1053,557,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1054,557,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1055,558,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1056,558,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1057,559,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1058,559,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1059,560,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1060,560,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1061,561,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1062,561,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1063,562,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1064,562,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1065,563,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1066,563,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1067,564,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1068,564,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1069,565,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1070,565,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1071,566,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1072,566,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1073,567,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1074,567,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1075,568,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1076,568,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1077,569,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1078,569,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1079,570,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1080,570,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1081,571,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1082,571,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1083,572,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1084,572,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1085,573,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1086,573,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1087,574,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1088,574,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1089,575,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1090,575,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1091,576,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1092,576,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1093,577,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1094,577,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1095,578,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1096,578,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1097,579,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1098,579,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1099,580,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1100,580,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1101,581,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1102,581,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1103,582,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1104,582,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1105,583,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1106,583,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1107,584,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1108,584,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1109,585,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1110,585,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1111,586,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1112,586,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1113,587,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1114,587,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1115,588,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1116,588,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1117,589,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1118,589,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1119,590,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1120,590,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1121,591,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1122,591,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1123,592,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1124,592,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1125,593,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1126,593,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1127,594,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1128,594,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1129,595,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1130,595,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1131,596,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1132,596,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1133,597,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1134,597,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1135,598,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1136,598,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1137,599,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1138,599,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1139,600,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1140,600,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1141,601,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(1142,601,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(1143,602,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(1144,602,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(1145,603,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(1146,603,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(1147,604,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(1148,604,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(1149,605,'http://schema.hls.com/extension#temperature','hls',20,NULL,NULL,NULL),(1150,605,'http://schema.hls.com/extension#batchNumber','hls',1,NULL,NULL,NULL),(1151,606,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1152,606,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1153,607,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1154,607,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1155,608,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1156,608,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1157,609,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1158,609,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1159,610,'http://schema.hls.com/extension#temperature','hls',30,NULL,NULL,NULL),(1160,610,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1161,611,'http://schema.hls.com/extension#temperature','hls',22,NULL,NULL,NULL),(1162,612,'http://schema.hls.com/extension#temperature','hls',22,NULL,NULL,NULL),(1163,613,'http://schema.hls.com/extension#temperature','hls',22,NULL,NULL,NULL),(1164,614,'http://schema.hls.com/extension#temperature','hls',22,NULL,NULL,NULL),(1165,615,'http://schema.hls.com/extension#temperature','hls',22,NULL,NULL,NULL),(1166,616,'http://schema.hls.com/extension#temperature','hls',22,NULL,NULL,NULL),(1167,617,'http://schema.hls.com/extension#temperature','hls',22,NULL,NULL,NULL),(1168,618,'http://schema.hls.com/extension#temperature','hls',22,NULL,NULL,NULL),(1169,619,'http://schema.hls.com/extension#temperature','hls',22,NULL,NULL,NULL),(1170,620,'http://schema.hls.com/extension#temperature','hls',22,NULL,NULL,NULL),(1171,621,'http://schema.hls.com/extension#temperature','hls',19,NULL,NULL,NULL),(1172,622,'http://schema.hls.com/extension#temperature','hls',19,NULL,NULL,NULL),(1173,623,'http://schema.hls.com/extension#temperature','hls',19,NULL,NULL,NULL),(1174,624,'http://schema.hls.com/extension#temperature','hls',19,NULL,NULL,NULL),(1175,625,'http://schema.hls.com/extension#temperature','hls',19,NULL,NULL,NULL),(1254,670,'http://schema.hls.com/extension#temperature','hls',49,NULL,NULL,NULL),(1255,670,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1256,671,'http://schema.hls.com/extension#temperature','hls',48,NULL,NULL,NULL),(1257,671,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1258,673,'http://schema.hls.com/extension#temperature','hls',49,NULL,NULL,NULL),(1259,673,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1260,674,'http://schema.hls.com/extension#temperature','hls',48,NULL,NULL,NULL),(1261,674,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1262,683,'http://schema.hls.com/extension#temperature','hls',49,NULL,NULL,NULL),(1263,683,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL),(1264,684,'http://schema.hls.com/extension#temperature','hls',48,NULL,NULL,NULL),(1265,684,'http://schema.hls.com/extension#batchNumber','hls',2,NULL,NULL,NULL);
INSERT INTO `event_QuantityEvent` VALUES (41,'2006-06-25 09:26:00',1151220360000,'2006-06-25 09:26:00',1151220360000,'-06:00',41,1,23,9,NULL,30),(42,'2006-06-25 09:27:00',1151220420000,'2006-06-25 09:27:00',1151220420000,'-06:00',42,2,23,9,NULL,30),(43,'2006-06-25 09:28:00',1151220480000,'2006-06-25 09:28:00',1151220480000,'-06:00',43,3,23,9,NULL,30),(44,'2006-06-25 09:29:00',1151220540000,'2006-06-25 09:29:00',1151220540000,'-06:00',44,4,23,9,NULL,30),(45,'2006-06-25 09:30:00',1151220600000,'2006-06-25 09:30:00',1151220600000,'-06:00',45,5,23,9,NULL,30),(46,'2006-06-25 09:31:00',1151220660000,'2006-06-25 09:31:00',1151220660000,'-06:00',46,6,23,9,NULL,30),(47,'2006-06-25 09:32:00',1151220720000,'2006-06-25 09:32:00',1151220720000,'-06:00',47,7,23,9,NULL,30),(48,'2006-06-25 09:33:00',1151220780000,'2006-06-25 09:33:00',1151220780000,'-06:00',48,8,23,9,NULL,30),(49,'2006-06-25 09:34:00',1151220840000,'2006-06-25 09:34:00',1151220840000,'-06:00',49,9,23,9,NULL,30),(50,'2006-06-25 09:35:00',1151220900000,'2006-06-25 09:35:00',1151220900000,'-06:00',50,10,23,9,NULL,30);
INSERT INTO `event_TransactionEvent` VALUES (41,'2006-06-25 07:16:00',1151212560000,'2006-06-25 07:16:00',1151212560000,'-06:00',NULL,'ADD',25,10,24,28),(42,'2006-06-25 07:17:00',1151212620000,'2006-06-25 07:17:00',1151212620000,'-06:00',NULL,'ADD',25,10,24,28),(43,'2006-06-25 07:18:00',1151212680000,'2006-06-25 07:18:00',1151212680000,'-06:00',NULL,'ADD',25,10,24,28),(44,'2006-06-25 07:19:00',1151212740000,'2006-06-25 07:19:00',1151212740000,'-06:00',NULL,'ADD',25,10,24,28),(45,'2006-06-25 07:20:00',1151212800000,'2006-06-25 07:20:00',1151212800000,'-06:00',NULL,'ADD',25,10,24,28),(46,'2006-06-25 08:21:00',1151216460000,'2006-06-25 08:21:00',1151216460000,'-06:00',NULL,'OBSERVE',23,10,25,29),(47,'2006-06-25 08:22:00',1151216520000,'2006-06-25 08:22:00',1151216520000,'-06:00',NULL,'OBSERVE',23,10,25,29),(48,'2006-06-25 08:23:00',1151216580000,'2006-06-25 08:23:00',1151216580000,'-06:00',NULL,'OBSERVE',23,10,25,29),(49,'2006-06-25 08:24:00',1151216640000,'2006-06-25 08:24:00',1151216640000,'-06:00',NULL,'OBSERVE',23,10,25,29),(50,'2006-06-25 08:25:00',1151216700000,'2006-06-25 08:25:00',1151216700000,'-06:00',NULL,'OBSERVE',23,10,25,29);
INSERT INTO `event_TransactionEvent_bizTrans` VALUES (41,41,0),(41,46,1),(42,42,2),(42,47,3),(43,43,4),(43,48,5),(44,44,6),(44,49,7),(45,45,8),(45,50,9),(46,41,10),(46,46,11),(47,42,12),(47,47,13),(48,43,14),(48,48,15),(49,44,16),(49,49,17),(50,45,18),(50,50,19);
INSERT INTO `event_TransactionEvent_EPCs` VALUES (41,'urn:epc:id:sgtin:0614141.107340.1',0),(41,'urn:epc:id:sgtin:0614141.107340.2',1),(41,'urn:epc:id:sgtin:0614141.107340.3',2),(41,'urn:epc:id:sgtin:0614141.107340.4',3),(41,'urn:epc:id:sgtin:0614141.107340.5',4),(41,'urn:epc:id:sgtin:0614141.107340.6',5),(41,'urn:epc:id:sgtin:0614141.107340.7',6),(41,'urn:epc:id:sgtin:0614141.107340.8',7),(41,'urn:epc:id:sgtin:0614141.107340.9',8),(41,'urn:epc:id:sgtin:0614141.107340.10',9),(41,'urn:epc:id:sgtin:0614141.107341.1',10),(41,'urn:epc:id:sgtin:0614141.107341.2',11),(41,'urn:epc:id:sgtin:0614141.107341.3',12),(41,'urn:epc:id:sgtin:0614141.107341.4',13),(41,'urn:epc:id:sgtin:0614141.107341.5',14),(41,'urn:epc:id:sgtin:0614141.107341.6',15),(41,'urn:epc:id:sgtin:0614141.107341.7',16),(41,'urn:epc:id:sgtin:0614141.107341.8',17),(41,'urn:epc:id:sgtin:0614141.107341.9',18),(41,'urn:epc:id:sgtin:0614141.107341.10',19),(42,'urn:epc:id:sgtin:0614141.107342.1',20),(42,'urn:epc:id:sgtin:0614141.107342.2',21),(42,'urn:epc:id:sgtin:0614141.107342.3',22),(42,'urn:epc:id:sgtin:0614141.107342.4',23),(42,'urn:epc:id:sgtin:0614141.107342.5',24),(42,'urn:epc:id:sgtin:0614141.107342.6',25),(42,'urn:epc:id:sgtin:0614141.107342.7',26),(42,'urn:epc:id:sgtin:0614141.107342.8',27),(42,'urn:epc:id:sgtin:0614141.107342.9',28),(42,'urn:epc:id:sgtin:0614141.107342.10',29),(42,'urn:epc:id:sgtin:0614141.107343.1',30),(42,'urn:epc:id:sgtin:0614141.107343.2',31),(42,'urn:epc:id:sgtin:0614141.107343.3',32),(42,'urn:epc:id:sgtin:0614141.107343.4',33),(42,'urn:epc:id:sgtin:0614141.107343.5',34),(42,'urn:epc:id:sgtin:0614141.107343.6',35),(42,'urn:epc:id:sgtin:0614141.107343.7',36),(42,'urn:epc:id:sgtin:0614141.107343.8',37),(42,'urn:epc:id:sgtin:0614141.107343.9',38),(42,'urn:epc:id:sgtin:0614141.107343.10',39),(43,'urn:epc:id:sgtin:0614141.107344.1',40),(43,'urn:epc:id:sgtin:0614141.107344.2',41),(43,'urn:epc:id:sgtin:0614141.107344.3',42),(43,'urn:epc:id:sgtin:0614141.107344.4',43),(43,'urn:epc:id:sgtin:0614141.107344.5',44),(43,'urn:epc:id:sgtin:0614141.107344.6',45),(43,'urn:epc:id:sgtin:0614141.107344.7',46),(43,'urn:epc:id:sgtin:0614141.107344.8',47),(43,'urn:epc:id:sgtin:0614141.107344.9',48),(43,'urn:epc:id:sgtin:0614141.107344.10',49),(43,'urn:epc:id:sgtin:0614142.107345.1',50),(43,'urn:epc:id:sgtin:0614142.107345.2',51),(43,'urn:epc:id:sgtin:0614142.107345.3',52),(43,'urn:epc:id:sgtin:0614142.107345.4',53),(43,'urn:epc:id:sgtin:0614142.107345.5',54),(43,'urn:epc:id:sgtin:0614142.107345.6',55),(43,'urn:epc:id:sgtin:0614142.107345.7',56),(43,'urn:epc:id:sgtin:0614142.107345.8',57),(43,'urn:epc:id:sgtin:0614142.107345.9',58),(43,'urn:epc:id:sgtin:0614142.107345.10',59),(44,'urn:epc:id:sgtin:0614142.107346.1',60),(44,'urn:epc:id:sgtin:0614142.107346.2',61),(44,'urn:epc:id:sgtin:0614142.107346.3',62),(44,'urn:epc:id:sgtin:0614142.107346.4',63),(44,'urn:epc:id:sgtin:0614142.107346.5',64),(44,'urn:epc:id:sgtin:0614142.107346.6',65),(44,'urn:epc:id:sgtin:0614142.107346.7',66),(44,'urn:epc:id:sgtin:0614142.107346.8',67),(44,'urn:epc:id:sgtin:0614142.107346.9',68),(44,'urn:epc:id:sgtin:0614142.107346.10',69),(44,'urn:epc:id:sgtin:0614142.107347.1',70),(44,'urn:epc:id:sgtin:0614142.107347.2',71),(44,'urn:epc:id:sgtin:0614142.107347.3',72),(44,'urn:epc:id:sgtin:0614142.107347.4',73),(44,'urn:epc:id:sgtin:0614142.107347.5',74),(44,'urn:epc:id:sgtin:0614142.107347.6',75),(44,'urn:epc:id:sgtin:0614142.107347.7',76),(44,'urn:epc:id:sgtin:0614142.107347.8',77),(44,'urn:epc:id:sgtin:0614142.107347.9',78),(44,'urn:epc:id:sgtin:0614142.107347.10',79),(45,'urn:epc:id:sgtin:0614142.107348.1',80),(45,'urn:epc:id:sgtin:0614142.107348.2',81),(45,'urn:epc:id:sgtin:0614142.107348.3',82),(45,'urn:epc:id:sgtin:0614142.107348.4',83),(45,'urn:epc:id:sgtin:0614142.107348.5',84),(45,'urn:epc:id:sgtin:0614142.107348.6',85),(45,'urn:epc:id:sgtin:0614142.107348.7',86),(45,'urn:epc:id:sgtin:0614142.107348.8',87),(45,'urn:epc:id:sgtin:0614142.107348.9',88),(45,'urn:epc:id:sgtin:0614142.107348.10',89),(45,'urn:epc:id:sgtin:0614142.107349.1',90),(45,'urn:epc:id:sgtin:0614142.107349.2',91),(45,'urn:epc:id:sgtin:0614142.107349.3',92),(45,'urn:epc:id:sgtin:0614142.107349.4',93),(45,'urn:epc:id:sgtin:0614142.107349.5',94),(45,'urn:epc:id:sgtin:0614142.107349.6',95),(45,'urn:epc:id:sgtin:0614142.107349.7',96),(45,'urn:epc:id:sgtin:0614142.107349.8',97),(45,'urn:epc:id:sgtin:0614142.107349.9',98),(45,'urn:epc:id:sgtin:0614142.107349.10',99),(46,'urn:epc:id:sgtin:0614141.107340.1',100),(46,'urn:epc:id:sgtin:0614141.107340.2',101),(46,'urn:epc:id:sgtin:0614141.107340.3',102),(46,'urn:epc:id:sgtin:0614141.107340.4',103),(46,'urn:epc:id:sgtin:0614141.107340.5',104),(46,'urn:epc:id:sgtin:0614141.107340.6',105),(46,'urn:epc:id:sgtin:0614141.107340.7',106),(46,'urn:epc:id:sgtin:0614141.107340.8',107),(46,'urn:epc:id:sgtin:0614141.107340.9',108),(46,'urn:epc:id:sgtin:0614141.107340.10',109),(46,'urn:epc:id:sgtin:0614141.107341.1',110),(46,'urn:epc:id:sgtin:0614141.107341.2',111),(46,'urn:epc:id:sgtin:0614141.107341.3',112),(46,'urn:epc:id:sgtin:0614141.107341.4',113),(46,'urn:epc:id:sgtin:0614141.107341.5',114),(46,'urn:epc:id:sgtin:0614141.107341.6',115),(46,'urn:epc:id:sgtin:0614141.107341.7',116),(46,'urn:epc:id:sgtin:0614141.107341.8',117),(46,'urn:epc:id:sgtin:0614141.107341.9',118),(46,'urn:epc:id:sgtin:0614141.107341.10',119),(47,'urn:epc:id:sgtin:0614141.107342.1',120),(47,'urn:epc:id:sgtin:0614141.107342.2',121),(47,'urn:epc:id:sgtin:0614141.107342.3',122),(47,'urn:epc:id:sgtin:0614141.107342.4',123),(47,'urn:epc:id:sgtin:0614141.107342.5',124),(47,'urn:epc:id:sgtin:0614141.107342.6',125),(47,'urn:epc:id:sgtin:0614141.107342.7',126),(47,'urn:epc:id:sgtin:0614141.107342.8',127),(47,'urn:epc:id:sgtin:0614141.107342.9',128),(47,'urn:epc:id:sgtin:0614141.107342.10',129),(47,'urn:epc:id:sgtin:0614141.107343.1',130),(47,'urn:epc:id:sgtin:0614141.107343.2',131),(47,'urn:epc:id:sgtin:0614141.107343.3',132),(47,'urn:epc:id:sgtin:0614141.107343.4',133),(47,'urn:epc:id:sgtin:0614141.107343.5',134),(47,'urn:epc:id:sgtin:0614141.107343.6',135),(47,'urn:epc:id:sgtin:0614141.107343.7',136),(47,'urn:epc:id:sgtin:0614141.107343.8',137),(47,'urn:epc:id:sgtin:0614141.107343.9',138),(47,'urn:epc:id:sgtin:0614141.107343.10',139),(48,'urn:epc:id:sgtin:0614141.107344.1',140),(48,'urn:epc:id:sgtin:0614141.107344.2',141),(48,'urn:epc:id:sgtin:0614141.107344.3',142),(48,'urn:epc:id:sgtin:0614141.107344.4',143),(48,'urn:epc:id:sgtin:0614141.107344.5',144),(48,'urn:epc:id:sgtin:0614141.107344.6',145),(48,'urn:epc:id:sgtin:0614141.107344.7',146),(48,'urn:epc:id:sgtin:0614141.107344.8',147),(48,'urn:epc:id:sgtin:0614141.107344.9',148),(48,'urn:epc:id:sgtin:0614141.107344.10',149),(48,'urn:epc:id:sgtin:0614142.107345.1',150),(48,'urn:epc:id:sgtin:0614142.107345.2',151),(48,'urn:epc:id:sgtin:0614142.107345.3',152),(48,'urn:epc:id:sgtin:0614142.107345.4',153),(48,'urn:epc:id:sgtin:0614142.107345.5',154),(48,'urn:epc:id:sgtin:0614142.107345.6',155),(48,'urn:epc:id:sgtin:0614142.107345.7',156),(48,'urn:epc:id:sgtin:0614142.107345.8',157),(48,'urn:epc:id:sgtin:0614142.107345.9',158),(48,'urn:epc:id:sgtin:0614142.107345.10',159),(49,'urn:epc:id:sgtin:0614142.107346.1',160),(49,'urn:epc:id:sgtin:0614142.107346.2',161),(49,'urn:epc:id:sgtin:0614142.107346.3',162),(49,'urn:epc:id:sgtin:0614142.107346.4',163),(49,'urn:epc:id:sgtin:0614142.107346.5',164),(49,'urn:epc:id:sgtin:0614142.107346.6',165),(49,'urn:epc:id:sgtin:0614142.107346.7',166),(49,'urn:epc:id:sgtin:0614142.107346.8',167),(49,'urn:epc:id:sgtin:0614142.107346.9',168),(49,'urn:epc:id:sgtin:0614142.107346.10',169),(49,'urn:epc:id:sgtin:0614142.107347.1',170),(49,'urn:epc:id:sgtin:0614142.107347.2',171),(49,'urn:epc:id:sgtin:0614142.107347.3',172),(49,'urn:epc:id:sgtin:0614142.107347.4',173),(49,'urn:epc:id:sgtin:0614142.107347.5',174),(49,'urn:epc:id:sgtin:0614142.107347.6',175),(49,'urn:epc:id:sgtin:0614142.107347.7',176),(49,'urn:epc:id:sgtin:0614142.107347.8',177),(49,'urn:epc:id:sgtin:0614142.107347.9',178),(49,'urn:epc:id:sgtin:0614142.107347.10',179),(50,'urn:epc:id:sgtin:0614142.107348.1',180),(50,'urn:epc:id:sgtin:0614142.107348.2',181),(50,'urn:epc:id:sgtin:0614142.107348.3',182),(50,'urn:epc:id:sgtin:0614142.107348.4',183),(50,'urn:epc:id:sgtin:0614142.107348.5',184),(50,'urn:epc:id:sgtin:0614142.107348.6',185),(50,'urn:epc:id:sgtin:0614142.107348.7',186),(50,'urn:epc:id:sgtin:0614142.107348.8',187),(50,'urn:epc:id:sgtin:0614142.107348.9',188),(50,'urn:epc:id:sgtin:0614142.107348.10',189),(50,'urn:epc:id:sgtin:0614142.107349.1',190),(50,'urn:epc:id:sgtin:0614142.107349.2',191),(50,'urn:epc:id:sgtin:0614142.107349.3',192),(50,'urn:epc:id:sgtin:0614142.107349.4',193),(50,'urn:epc:id:sgtin:0614142.107349.5',194),(50,'urn:epc:id:sgtin:0614142.107349.6',195),(50,'urn:epc:id:sgtin:0614142.107349.7',196),(50,'urn:epc:id:sgtin:0614142.107349.8',197),(50,'urn:epc:id:sgtin:0614142.107349.9',198),(50,'urn:epc:id:sgtin:0614142.107349.10',199);


INSERT INTO `voc_BizLoc` (`id`, `uri`) VALUES
(22, 'urn:epcglobal:fmcg:loc:0614141073467'),
(23, 'urn:epcglobal:fmcg:loc:0614141073468'),
(24, 'urn:epcglobal:fmcg:loc:0614141073469'),
(25, 'urn:epcglobal:fmcg:loc:0614141073467.1'),
(26, 'urn:epcglobal:fmcg:loc:0614141073468.1'),
(27, 'urn:epcglobal:fmcg:loc:0614141073468.2'),
(28, 'urn:epcglobal:fmcg:loc:0614141073468.3'),
(29, 'urn:epcglobal:fmcg:loc:0614141073469.1'),
(30, 'urn:epcglobal:fmcg:loc:0614141073469.2');

INSERT INTO `voc_BizLoc_attr` (`id`,`attribute`,`value`) VALUES
(22, 'urn:epcglobal:fmcg:mda:gln', '0614141073467'),
(25, 'urn:epcglobal:fmcg:mda:sslt', '208'),
(25, 'urn:epcglobal:fmcg:mda:sslta', '422'),
(22, 'urn:epcglobal:fmcg:mda:gln', '0614141073467'),
(23, 'urn:epcglobal:fmcg:mda:gln', '0614141073468'),
(26, 'urn:epcglobal:fmcg:mda:gln', '0614141073468'),
(26, 'urn:epcglobal:fmcg:mda:sslt', '209'),
(27, 'urn:epcglobal:fmcg:mda:gln', '0614141073468'),
(27, 'urn:epcglobal:fmcg:mda:sslt', '299'),
(27, 'urn:epcglobal:fmcg:mda:sslta', '422'),
(28, 'urn:epcglobal:fmcg:mda:gln', '0614141073468'),
(28, 'urn:epcglobal:fmcg:mda:sslt', '210'),
(24, 'urn:epcglobal:fmcg:mda:gln', '0614141073469'),
(29, 'urn:epcglobal:fmcg:mda:gln', '0614141073469'),
(29, 'urn:epcglobal:fmcg:mda:sslt', '209'),
(30, 'urn:epcglobal:fmcg:mda:gln', '0614141073469'),
(30, 'urn:epcglobal:fmcg:mda:sslt', '201');

INSERT INTO `voc_BizStep` (`id`, `uri`) VALUES 
(21, 'urn:epcglobal:hls:bizstep:commissioning'),
(22, 'urn:epcglobal:hls:bizstep:casetopalletaggregation'),
(23, 'urn:epcglobal:fmcg:bizstep:receiving'),
(24, 'urn:epcglobal:fmcg:bizstep:picking'),
(25, 'urn:epcglobal:fmcg:bizstep:shipping');

INSERT INTO `voc_BizTrans` (`id`, `uri`) VALUES 
(41, 'urn:epcglobal:fmcg:bti:po:0614141073468.1'),
(42, 'urn:epcglobal:fmcg:bti:po:0614141073468.2'),
(43, 'urn:epcglobal:fmcg:bti:po:0614141073468.3'),
(44, 'urn:epcglobal:fmcg:bti:po:0614141073468.4'),
(45, 'urn:epcglobal:fmcg:bti:po:0614141073468.5'),
(46, 'urn:epcglobal:fmcg:bti:bol:0614141073468.A'),
(47, 'urn:epcglobal:fmcg:bti:bol:0614141073468.B'),
(48, 'urn:epcglobal:fmcg:bti:bol:0614141073468.C'),
(49, 'urn:epcglobal:fmcg:bti:bol:0614141073468.D'),
(50, 'urn:epcglobal:fmcg:bti:bol:0614141073468.E');

INSERT INTO `voc_BizTransType` (`id`, `uri`) VALUES 
(9, 'urn:epcglobal:fmcg:btt:po'),
(10, 'urn:epcglobal:fmcg:btt:bol');

INSERT INTO `voc_Disposition` (`id`,`uri`) VALUES
(9, 'urn:epcglobal:hls:disp:active'),
(10, 'urn:epcglobal:fmcg:disp:sellable_available');

INSERT INTO `voc_EPCClass` (`id`,`uri`) VALUES
(41, 'urn:epc:idpat:sgtin:0614141.107340.*'),
(42, 'urn:epc:idpat:sgtin:0614141.107341.*'),
(43, 'urn:epc:idpat:sgtin:0614141.107342.*'),
(44, 'urn:epc:idpat:sgtin:0614141.107343.*'),
(45, 'urn:epc:idpat:sgtin:0614141.107344.*'),
(46, 'urn:epc:idpat:sgtin:0614142.107345.*'),
(47, 'urn:epc:idpat:sgtin:0614142.107346.*'),
(48, 'urn:epc:idpat:sgtin:0614142.107347.*'),
(49, 'urn:epc:idpat:sgtin:0614142.107348.*'),
(50, 'urn:epc:idpat:sgtin:0614142.107349.*');

INSERT INTO `voc_ReadPoint` (`id`,`uri`) VALUES
(21, 'urn:epcglobal:fmcg:loc:0614141073467.RP-1'),
(22, 'urn:epcglobal:fmcg:loc:0614141073468.RP-1'),
(23, 'urn:epcglobal:fmcg:loc:0614141073468.RP-2'),
(24, 'urn:epcglobal:fmcg:loc:0614141073468.RP-3'),
(25, 'urn:epcglobal:fmcg:loc:0614141073469.RP-1');

INSERT INTO `voc_ReadPoint_attr` (`id`,`attribute`,`value`) VALUES
(21, 'urn:epcglobal:fmcg:mda:gln', '0614141073467'),
(22, 'urn:epcglobal:fmcg:mda:gln', '0614141073468'),
(23, 'urn:epcglobal:fmcg:mda:gln', '0614141073468'),
(24, 'urn:epcglobal:fmcg:mda:gln', '0614141073468'),
(25, 'urn:epcglobal:fmcg:mda:gln', '0614141073469'),
(21, 'urn:epcglobal:fmcg:mda:sslt', '208'),
(22, 'urn:epcglobal:fmcg:mda:sslt', '209'),
(23, 'urn:epcglobal:fmcg:mda:sslt', '299'),
(24, 'urn:epcglobal:fmcg:mda:sslt', '210'),
(25, 'urn:epcglobal:fmcg:mda:sslt', '209'),
(21, 'urn:epcglobal:fmcg:mda:sslta', '422'),
(22, 'urn:epcglobal:fmcg:mda:sslta', '414'),
(23, 'urn:epcglobal:fmcg:mda:sslta', '422'),
(24, 'urn:epcglobal:fmcg:mda:sslta', '414'),
(25, 'urn:epcglobal:fmcg:mda:sslta', '414'),
(21, 'urn:epcglobal:fmcg:mda:sle', 'PackagingLineX'),
(22, 'urn:epcglobal:fmcg:mda:sle', 'DockDoor3'),
(23, 'urn:epcglobal:fmcg:mda:sle', 'PickArea5'),
(24, 'urn:epcglobal:fmcg:mda:sle', 'DockDoor6'),
(25, 'urn:epcglobal:fmcg:mda:sle', 'DockDoor1');

COMMIT;
